package edu.zut.mapper;

import edu.zut.pojo.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

@Mapper
public interface UserMapper {


    @Select("select * from user_info where email = #{email}")
    UserInfo findEmail(String email);

    @Select("select * from user_info")
    List<UserInfo> findAll();

    @Update("update user_info set zym = #{zym} where email= #{email}")
    int saveZym(String email, String zym);

}
